SUMMARY

• 7+ years of extensive IT experience in MSSQL Server SQL Server 2000/2005/2008/2008 R2 and 2012.
• Strong and In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics in Production, Development and Test Environments.
• Solid experience in database development and support
• SQL database design, architecture, data modeling (logical and physical design) using ERWIN and VISIO.
• Thorough understanding and experience in data warehouse and data mart design, star schema, snowflake schema, normalization and demoralization concepts and principles.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, and Data Migration projects.
• Knowledge of Database tools like SQL Profiler, Database Engine Tuning Advisor, Erwin, Visio.
• Expert in creating Indexes, Views, Triggers, effective Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Implemented various SSIS Transformations such as Slowly Changing Dimensions, Look up, Derived Column, Aggregate, Fuzzy Lookup, Multicast, Conditional Split, Data Conversion etc
• Expert in database activities like Database creation and Maintenance, Performance Monitoring, Tuning and Troubleshooting
• Created, optimized and deployed various cubes using SSAS depending upon business needs for slicing and dicing data from different angles
• Expertise in generating reports using SQL Server Reporting Services (SSRS), Crystal Reports and Excel spreadsheet.
• Used Report builder and provided multiple types of reports in SQL Server Reporting Services (SSRS) including drill down, drill through, parameterized, sub reports and linked reports
• Experience in scheduling and deploying reports on report manger.
• High availability support for SQL Server Failover clustering, database mirroring, log shipping, replication.
• Hands on experience on SQL Server Notification Service, Service Broker.
• Solid experience in software development life cycle and n-tier applications development.
• Consistent, well-organized and dependable performer with the flexibility to adapt to constantly shifting priorities.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.

PROFESSIONAL EXPERIENCE

SQL/BI Developer

Confidential, Pasadena, CA

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Modified and supported in-house .NET application using C#, MS SQL
• Coded Web-based applications using ASP, ASP.NET, C#
• Responsible for Logical and Physical design of Database using Erwin data modeler.
• Enhanced SSIS packages to put in order policy data feeds from different brokers and OLTP in a consistent manner, plan to generate month end feeds for financial report system and to load policy transactions from different brokers/agencies.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Used the SSIS script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Developed packages to handle slowly changing dimensions, data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )
• Designed relationships between the dimensions and measures. Resolved complex many to many relationships and d relationships between the dimensions and the measures.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Configured the report server service account and report server database in SSRS
• Used MDX to query the OLAP database in order to generate OLAP reports.
• Defined Key Performance Indicators (KPI) in SSAS.
• Set up Partitioned Tables and Indexes for Parallel Processing of queries using SQL Server Partition functions and schemes.

Environment: Windows 2003 server, Microsoft SQL Server 2008/2012, C#.net, ASP.NET, ADO.net Microsoft Access, SQL Server Profiler, SSIS, SSRS, SSAS, Visual Studio 2008/2010.

MSSQL Server/ BI Developer

Confidential, San Jose, CA

Responsibilities:

• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analysis inSQLServer Management Studio.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
• Built efficient SSIS packages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and ExecuteSQLtask to load new projects data into theSQLtables
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, ExecuteSQLTask, 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.
• Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as .
• Created database maintenance tasks like re-indexing, updating statistics and index de-fragmentation.
• Developed Stored Procedures, User Defined Functions and Views to implement the Data Warehouse ETL Process.
• Developed Complex Stored Procedures and User Defined Functions to create a Sync Engine in order to synchronize two databases from different companies.
• Used Change Tracking to capture the changes in the data during the ETL process.
• Involved in managingdevelopers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: SQL Server /2008/2008R2/2012, MS BIDS, T-SQL, SSRS, SSIS, Erwin 4.x

MS SQL Server Developer/ SSRS, SSIS, SSAS

Confidential, Philadelphia, PA

Responsibilities:

• Analyzed existing database for different business units and documented.
• Created physical and logical structure of the new data warehouse (SQL database) and process work flow by using ERWIN.
• Created several tables, views and stored procedures using SQL Server 2008.
• Developed several ETL packages and data flow tasks by using SSIS.
• Extracted data from DB2 and stored in to SQL Staging tables in BI Staging database.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP (DB2) to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Developed several complex MDX queries and used those to build the reports by using SSRS.
• Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS 2008, Excel 2007.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Responsible to create all the SSRS report using Cube as data source.
• Familiar with MDX, development of offline cubes, Expert in defining calculated members, KPI's, developing and modifying multi-dimensional cubes and dimensions using SQL Server Analysis Services (SSAS).
• Created different data points and pulling those using SSIS package.
• Developed several Ad-hoc reports by using MS Excel Responsible to create several SSIS schedule tasks and monitor those tasks regularly.
• Developed high level daily summary report and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, Windows Server 2003, DB2, MS Office 2003, Excel 2007, ERWIN.

SQL Server/ SSRS Developer

Confidential, Round Rock, Texas

Responsibilities:

• Reviewed, Developed and Designed Data Models in conjunction with the application development team.
• Encapsulated frequently used SQL statement into Stored Procedures thereby reducing the execution time.
• Designed and developed various complex reports using MS reporting services and deploy public reports in dynamic web portal.
• Created and integrated user defined functions and store procedure for reporting purposes.
• Generated reports than can handle dynamic grouping and dynamic sorting.
• Designed and created Report Templates, Bar Graphs and Pie Charts.
• Generated report using global variable, expressions and functions.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports, implemented AD HOC reporting with the report builder for the end users.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Created data driven subscriptions for different users using Report Manager.

Environment: MS SQL Server 2008/2005, SSRS-2008/2005, Erwin, Enterprise, vb.net, Visual Studio 2008/2005.

SQL Server Developer

Confidential

Responsibilities:

• Created Database as per the requirement using SQL server 2000.
• Maintained and supported the SQL Server databases as a developer helping administrator.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Written stored procedures and triggers to implement business rules.
• Involved in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Maintained disaster recovery Backup and Re-Indexing was implemented to increase the performance.
• Created user profiles and corresponding read, write and DDL and DML access properties were maintained on the database.
• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS, MS-Excel, MS-Office, Oracle8i and C.