Data Developer
Resume:
Mani Edpuganti
507-***-**** – **********@*****.***
** + years of IT experience as a Senior Microsoft SQL Server Developer in creating Business Intelligence solutions using ETL tools (SSIS), OLAP (SSAS) and reporting tool (SSRS). Expertise in designing and implementing complex ETL and reporting solutions as per business needs in different domains such as Insurance, HealthCare, Banking and Finance.
Summary
Extensively worked in all phases of Software Development Life Cycle which includes designing, developing, Testing, Implementation, Documentation and support of software application using Microsoft SQL Server, My-SQL, MS-Access and Visual Studio.
Highly experienced in Relational Database Management System (RDMS), MS SQL Server in writing T-SQL, Data Analysis and Data Migration.
Experienced in writing T-SQL queries, stored procedures, user defined functions, dynamic-queries, indexed views and DDL/DML triggers for data consistency and manipulation.
Experienced in normalizing and de-normalizing the tables and maintaining Integrity using types of SQL Server constraints (primary keys, foreign keys, defaults, checks, and unique).
Excellent experience in design and development of Business Intelligence tools using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
Experience in data Extraction, Transforming and Loading (ETL) using Various tools such as SQL Server Integration Services (SSIS 2008/2012), DTS, Bulk Insert and Bulk Copy Program Utility
Expertise in creating user defined variables, parameterized variables and managing event handlers, package configurations, logging for SSIS packages.
Experience in creating and deploying SSIS packages using various transformations such as slowly changing dimension, merge join, lookup, conditional split, aggregate, derived column, pivot, character mapping and data conversion transformations.
Proven ability in generating drill down and drill through reports with drop down option, ad-hoc reports, parameterized reports, sorting the data and defining subtotals in SSRS 2008.
Experience in analyzing execution plan, managing indexes and troubleshooting deadlocks.
In depth knowledge and understanding of all the stages in Software Development Life Cycle (SDLC).
Experience in working in tight schedules, result oriented & committed to meet the goal.
Relevant technical, analytical, managerial, interpersonal and organizational skills.
Knowledge of the consumer loan servicing application known as CRIF.
Knowledge of Symitar being used by credit Unions.
Knowledge in Tableau and Power BI.
Team player and self-starter with excellent communication and written skills.
Professional Experience
Sunrise Banks, Minneapolis MN
SSIS, SSRS, POWER BI, AZURE SQL Developer. August 18 – Present
Built SSIS packages to load flat files from external partners into the bank’s primary OLTP staging databases in support of the prepaid card business
Developed stored procedures, views and tables to merge flat file data from staging to production
Developed SSRS reports for business users to monitor, analyze and reconcile prepaid transactions
Administered MoveIT application (file transfer utility) – used to move flat files from bank DMZ FTP sites into the internal network for processing
Worked with Fiserv application support team to ensure prepaid data and ACH files feed to the Fiserv bank core was loaded in an accurate and timely manner
Utilize ITIL processes to move code changes from Dev to Production
Participated and presented to the Change Advisory Board (CAB) that reviews all functions that can affect the banks production environment.
Provided detailed documentation on work objects.
Worked directly with the business partners in the design and review of data flow, file types, Datatypes, frequency, ftp locations and such.
Involved in requirements gathering, analysis, design, development, change management, deployment.
Designed, developed and deployed Business Intelligence solutions using SSRS
Created Dax Queries to generated computed columns in Power BI.
Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files for the daily load to create and maintain a centralized Staging Database.
Designed and configured SSIS packages to migrate the data from legacy System using various transformations.
Developed ETL packages in SSIS and pulling data from different data warehouse databases like DB2.
Published Power BI Reports in the required originations and Made Power BI Dashboards
Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures
Analyzed and troubleshoot performance tuning SQL and complex SSIS packages.
Generated customer reports using SQL Server Reporting Services 2015/2017 from the OLTP data sources.
Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
Deployed and scheduled Reports using SSRS to generate daily, weekly, monthly and quarterly Reports including status.
Created standard report Subscriptions and Data Driven Report Subscriptions.
Environment: SQL Server 2017, Visual Studio 2017, 2019, SSIS, SSRS, Power BI, Azure SQL, MOVEIT
Wells Fargo, Minneapolis MN
Senior MSBI/SQL Developer August 17 – August 18
Worked with team lead, managers in validating the databases after the migrating to SQL Server 2014 environment.
After migrating the databases from SQL Server 2008 to SQL Server 2014 Dev environment validated the databases and deployed to UAT and created the scripts for the Prod environment.
Migrated old data from legacy system including 2008 and 2008R2 and external system excel and Oracle into SQL Server 2014 using SSIS Packages.
Developed SSIS packages using various control flow and dataflow components to transform and load the data from various databases into SQL Server 2014 and tested all the packages before deploying it to UAT and Prod Server.
Involved in source data analysis and creation of data mappings for extraction of bulk data from heterogeneous sources like oracle and Teradata.
Used Toad to validate the data in Oracle platform.
Developed and monitored and deployed SSIS Packages to SSIS Catalog in SQL Server documented all the new procedures, troubling shooting issues and solutions.
Scheduling and maintaining SSIS Package by creating new batch jobs thru SQL agent.
Modified the SSAS cubes to SQL server 2014 Dev Environment extracting the data from Teradata, Oracle and SQL Server and migrated to UAT.
Migrated the SSRS Reports to 2017 Report Server and modified the reports accordingly and extract the data from Oracle, Teradata and SQL Server.
Scheduled the subscription reports using the report wizard.
Environment: SQL Server 2008R2, 2012, 2014, SSIS, SSRS, SSAS, T-SQL, Windows 7, Visual Studio 2013/2015, Toad 12.8, Oarcle11g, Teradata15.10
Marine Credit Union, Lacrosse WI
Senior MSBI/ SQL Developer/Profiler/Tester April 15 – July 17
Interacting with the accounting department in acquiring the required information to generate T-SQL queries and do the required testing and generate report for the group and if required setup as a Subscription.
Written complex and extended T- SQL store procedures for the marketing department and set up the Subscriptions on a daily, weekly and monthly basis.
Extensively used Extract Transform Loading (ETL) tool using SSIS to populate data from various data sources to SQL Server 2012.
Written the stored procedures, checking the code for efficiency. Routine backups and restoration.
Used SSRS reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
Created ad-hoc, drill down, parameterized reports and drill through reports using SSRS and scheduled them for daily or monthly as needed.
Scheduled reports based on a particular day and sent them through email in required format (Excel, PDF)
Documented current database environment for new team members and provided continuous insights to the management and on modifications for better performance of the system.
Provided and Managed access to reports for different team members based on roles.
Environment: SQL Server 2008R2, 2012, 2016, SSIS, SSRS, SSAS, T-SQL, Windows 7, Visual Studio 2008/2010
Texas Health Resources, Arlington, TX
Senior MSBI/ SQL Developer Jul 13– Mar 15
Collected business requirements from users and translated them as technical specifications and design documents for development.
Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
Created stored procedures, triggers, indexes, user defined functions, constraints on various database objects to obtain the required results.
Transferred data from various data sources systems including MS Excel, MS Access, flat files to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
Responsible for scheduling jobs, alerting and maintaining SSIS packages.
Generated multiple enterprise reports (SSRS/Crystal/Impromptu) from SQL server database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, parameterized Reports
Developed cubes using SQL Server Analysis Services (SSAS) and experience in developing and extending OLAP cubes, dimensions and data source view.
Environment: MSSQL Server 2008/2005, Visual Studio 2005. Reporting Services (SSRS 2000/2005/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, ASP.NET, MS Access, SQL Server Analysis Services (SSAS).
Soliant Health, Atlanta, GA
MSBI/SQL Developer Sep 10 – Jun 13
Participated in development efforts to analyze client server applications using Visual Basic 6.0 as front-end tool and MS SQL Server Database.
Actively involved in analyzing the old database system and creating an environment and performed mappings to SQL Server 2005.
Involved in converting existing PL/SQL stored procedures, triggers, functions and script to T-SQL.
Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved
Performed data validation checks during staging, and then loaded the data into the data warehouse.
Provided documentation on current database environment and as well on the structure that needs to be modified in the future for better performance of the system.
Involved in installation, configuration of SSRS reporting server and involved in deploying reports.
Used SSRS reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
Created ad-hoc reports, drill down, and drill through reports using SSRS.
Deploying SSRS Reports across multiple environments including Test, Production and supporting environments.
Worked in the complete life cycle of the project, from the beginning i.e. planning stage to final i.e. giving the codes to production side.
Involved in database administration activities like back up, security, migrations in the development servers.
Environment: MSSQL Server 2008/2005, Visual Studio 2005. Reporting Services (SSRS 2000/2005/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, SQL Server Analysis Services (SSAS).
American Commerce Insurance Company, OH
SQL Developer Jan 08– Aug 10
Participated in development efforts to analyze client server applications using Visual Basic 6.0 as front-end tool and MS SQL Server Database.
Actively involved in analyzing the old database system and creating an environment and performed mappings to SQL Server 2008.
Involved in converting existing PL/SQL stored procedures, triggers, functions and script to T-SQL.
Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved
Performed data validation checks during staging, and then loaded the data into the data warehouse.
Involved in installation, configuration of SSRS reporting server and involved in deploying reports.
Used SSRS reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
Environment: MSSQL Server 2005, Query Analyzer, Index Tuning Wizard, MS Access, Windows Server 2003 Enterprise Edition.
Qualifications
Bachelors in Electronics and Communications
Contact this candidate