AnjaniKumar Kasiboyana

Total 3+ years hands on experience with building productionized data ingestion & processing pipelines using Snowflake, DBT and SQL, AWS, Data Modeling experienced in designing & implementing production grade data warehousing solutions on large scale data technologies. Having 3 years' experience as a Snowflake developer and 3 years' experience with DBT (Data Build Tool). Having good experience in Power BI, SSRS and Tableau reporting tools.

Software Engineer - Alten India Pvt

• SnowSQL & Snowpipe
• Converted Talend Job lets to support the snowflake functionality
• Created Snowpipe for continuous data load
• Used COPY to bulk load the data
• Created data sharing between two snowflake accounts
• Created internal & external stage & transformed data during load
• Redesigned the Views in snowflake to increase the performance
• Unit tested the data between Redshift & Snowflake
• Developed data warehouse model in snowflake for over 100 data sets using where Scape
• Created Reports in Looker based on Snowflake Connections
• Experienced in working with AWS, Azure & Google data services
• Validation of Looker report with Redshift database
• Good working knowledge of any ETL tool (Informatica or SSIS)
• Created Talend Mappings to populate the data into dimensions & fact tables
• Wrote ETL job stored from web API's using REST & HTTP calls & loaded into HDFS using java & Talend
• Used Talend big data components like S3 Buckets & AWS Services for redshift
• Validated data from SQL Server to Snowflake to make sure it has a match
• Consulting on Snowflake Data Platform Solution Architecture, Design, Development, & deployment focused to bring the data driven culture across the enterprise
• Building solutions once and for all with no band-aid approach
• Implemented Change Data Capture technology in Talend to load delta stoa Data Warehouse
• Developed stored procedures/views in Snowflake & use in Talend for loading Dimensions & Facts
• Designed, developed, tested, implemented & supported Data Warehousing ETL using Talend
• Excellent knowledge on RDBMS topics, ability to write complex SQL, PL/SQL
• Build python programming to extract data from AWS S3 and load into SQL server for one of business teams as they are not exposed to cloud
• Pull data from API's FTP Servers data into Snowflake
• Built custom input adapters to migrate data from FTP servers to S3
• Maintained version control of scripts and collaborated with the team using Bitbucket, Jira and Confluence
• Models of Core Banking System such as Corporate and Saving Account, Payment and Collection, Interest charges, Retail Teller, Corporate Lending

Software Engineer - Alten India Pvt

• Managing, grouping and scoring leads across different segments of Cash or Equity, Derivatives trading and Commodity trading from LeadSquared CRM tool
• Qualifying potential leads and pitching the best suitable Algo products according to their ledger balance in the trading account
• Creating customized email campaigns by using range of features in the CRM tool like drag and drop images, CTA buttons, and texts
• Capturing leads across all the sources in an accelerated manner to automate various and marketing processes
• Checking the performance of the Algo products based on its back test results
• Handling marketing dashboard of the different products listed in the internal trade store
• Conducting regular meetings with the vendors who listed their products in the Alice blue trade store to share the feedback of our targeted customers
• Following up the potential leads to convert into subscriptions

Graduation - SJC Institute of Technology (2018-06 - 2022-08)