SOUJANYA

Professional Summary:

●Over *+ years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 2008/2005/2000 in a high transaction and multi -server production environment. Self- learning ability and Leadership Quality.

●Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

●Expert in Extraction, Transforming and Loading (ETL) data using SSIS/DTS; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.

●Expert in creating T-SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.

●Experience in writing Distributed Queries between SQL Servers.

●Handled huge financial data, expert level query optimization and performance tuning experience.

●Experience in writing Row Count Validation queries for different kinds of data.

●Experience in creating Jobs, Alerts, setting up SQL server mail agent for SSIS packages.

●Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.

●Expertise skill in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard.

●Expertise in generating reports using Crystal Reports, SQL Server Reporting Services, and Microsoft Access & Excel spreadsheet.

●Experience in creating various reports like drill down, sub reports, parameterized, multi-valued reports through Report model creation.

●Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.

●Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise.

Technical Skills:

Languages

C,C++,T-SQL

Databases & Business Intelligence Tools

MS SQL Server 2012/2008/2005/2000, SQL Server Management Studio(SSMS), MS SQL Server Integration Services(SSIS)2012/2008/2005/2000, MS Access

Web Technologies

XML Web Services, Microsoft Office SharePoint Server (MOSS) 2007,.NET

Reporting Tools

SQL Server Reporting services 2012/2008/2005/2000, Tableau 7.0/8.0/8.1 server and desktop, QlikView, Crystal Reports

Web Server Technologies

Data Modeling Tool, ETL, Microsoft Visio

Operating System

Windows 2008, Windows 2000/2003 Server, data center, Windows NT, Windows 95/98/2000 XP, UNIX

Education: Bachelor of Technology (Information Technology) (JNTU, INDIA).

Project summary:

Client: Broadridge Financial Solutions, Jersey City, NJ June 2015 – present Role: DB Developer

Responsibilities:

Designed and coded application components in an Agile environment utilizing a test driven development approach.

Created and maintained project tasks and schedules.

Provided programming estimates, identified potential problems and recommended alternative solutions.

Worked in close cooperation with project managers and other functional team members to form a team effort in development.

Collaborated with other members of the product development team.

Participated in Daily Scrum Meetings and Sprint Retrospective and sprint planning for on time delivery of Business Needs.

Responsible and active in the analysis, design, implementation and deployment of full software development life-cycle (SDLC) of the project.

Defined the search criteria and pulled out the record of the customer from the database. Make the required changes to the record and save the updated information back to the database.

Developed user defined functions based on requirements.

Involved in data mappings.

Experience in writing Row Count Validation Queries for different kinds of data.

Used SSIS transformations such as, For-Each Loop Container, Sequence Container, Expressions, Execute SQL task and Providing Error Handling.

Involved in handling the changes in compiling scripts according to the database changes

Developed Data entry, query and reports request screens and tuned the SQL queries.

Used joins, indexes effectively in where clauses for Query optimization

Engaged in new development as well as support maintenance or enhancement of existing applications. Projects will entail complex business requirements and processes.

Responsible for detailed analysis and design using Microsoft Technologies for services that will support internal and external clients facilitate and deliver on business needs for functional and business mapping.

Worked extensively in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.

Environment: Microsoft Visual Studio, Team Foundation Server(TFS), Code Collaborator, SSRS, SSISMS SQL Server 2008 R2, T-SQL

Client: CSRA, Albany, NY Nov14-May15

Role: SQL/SSIS/SSRS Developer

Responsibilities:

Planned, defined and designed data based on business requirement and provided documentation for all kinds of reports, DTS and SSIS packages for further reference.

Developed SSIS Packages using Look Up Values & implementing rules provided by business in the mapping document.

Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

Modified the existing SSIS packages to meet the changes specified by the users.

Generated parameterized reports, sub reports, Drill down reports, Drill through reports using SSRS 2008 and 2008 R2.

Designed, developed and deployed reports in MS SQL Server environment using SSRS 2008 R2.

Created reports to retrieve data using Stored Procedures that accept parameters.

Fine-tuned SQL Queries for maximum efficiency and performance.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Worked in setup logging environment to track the status of the events like error raise, task fail.

Generated parameterized reports, sub reports, tabular reports using SSRS 2008.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.

Created reports which retrieve data using Stored Procedures that accept parameters.

Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

Responsible for Monitoring and Tuning Report performance.

Configured the report viewing security for various users at various levels using Report Manager

Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Environment:

MS SQL Server 2008 R2, SSRS, T-SQL, SSIS

Client: AT&T, Plano, TX Sep 2012 – Oct 2014

Role: SSIS/SSRS/SSAS Developer

Responsibilities:

Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Used SSIS jobs for importing data from the flat files that brings the data to the application tables.

Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.

Gained working knowledge in Data modeling, creating star and snowflake schemas in SSAS.

Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.

Created KPI Objects in line with Requirement Docs in SSAS.

Optimized and Aggregated cubes with 40% performance for better performance.

Processed cube to perform incremental updates.

Created reports by dragging data from cube and wrote MDX scripts in SSRS.

Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.

Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.

Worked on deploying and scheduling Reports using SSRS as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.

Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.

Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment:

MS SQL Server 2008 R2, SQL Server Reporting Services 2008 R2, SQL Server Integration Services 2008 R2, SQL Server Analysis Services 2008 R2, MS Visio 2007, Windows 7/ Vista and T-SQL.

Client: Pacer International, Dublin, OH Dec 2010 – Aug 2012

Role: MS SQL Server/SSIS/SSRS Developer

Responsibilities:

Created and modified stored procedures, triggers, views, partition function and schema for table partitioning.

Designed packages for Extracting, Transforming and Loading (ETL) data from Excel, Flat file and any OLE DB data source to MS SQL Server by using BCP utility and SSIS services.

Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task, Package Execution task to achieve business needs.

Monitored and Optimized SSIS package performance to reach the expected timeframe for data loading.

Used various transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived Column, Slowly Changing Dimension for performing different functionalities of the packages.

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using SSRS 2008.

Created tabular, matrix, chart, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.

Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.

Environment:

MS SQL Server 2008 R2, SSRS, T-SQL, SSIS.

Client: Magellan Medicaid Administration, Inc. Glen Allen, VA Oct 2009 – Nov 2010

Role: MS SQL Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

Planned, Defined and Designed database based on business requirement and provided documentation.

Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.

Gathered data and documented it for further reference and designed Database using Erwin data modeler.

Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

Modified the existing SSIS packages to meet the changes specified by the users.

Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.

Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).

Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment:

SQL Server 2008, BIDS, SSRS, SSIS, SSAS, Crystal Reports

Contact this candidate