SUMMARY

• 8+ years of IT experience as a MS SQL Server 2008R2/2008/2005 Developer in various industries like Real Estate Investment, Finance, Health Care and Educational Institutes.
• Conversant with all phases of the Software Development Life Cycle (SDLC) involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Supporting various day to day OLTP systems including MS SQL Server, DB2 and Inform ix in pulling data on a daily basis for business.
• Expert in T - SQL coding for Queries using Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and Functions.
• Experience in data modeling, query design and optimization.
• Experience creating and implementing physical databases from Logical Data Models.
• Expert in Logical and Physical Database design & development and Data modeling using the Erwin Data Modeler tool. Also performed consistency checks using DBCC utilities to ensure the physical consistency of the database and objects.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
• Expertise in using tools like the Index Tuning Wizard of the Database Engine and SQL Profiler for performance monitoring and tuning.
• Constructing SQL Server database objects (DDL) and implementing queries (DML) that perform the business functions of the database models.
• Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools and surrogate key generation.
• Expertise in performing ETL using SSIS, DTS, Bulk Insert and BCP.
• Experience in Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sy base and MS Access.
• Expertise in upgrading/migrating from DTS to SSIS packages. Experienced in resolving complex issues and error handling in SSIS.
• Used .NET in Script Task of SSIS to run SSIS packages from .NET environment.
• Experience in report generation using XML, MS Excel, SSRS and Tableau 7.0/8.0.
• Expert in creating Chart reports, Drill down and Drill through reports by passing parameters in SSRS.
• Experience in Developing and Deploying OLAP cubes, Facts and Dimension tables.
• Used MDX (Multi-dimensional Expressions) queries for calculated members of a cube and KPIs (Key Performance Indicators).
• Created Reports using MDX and SQL.
• Worked with XML document structures and hierarchical data.
• Experience in designing multi-tiered client/server applications.
• Experience in developing Web-based Applications with JSP, Java, PHP as font-end and MySQL and Oracle as back end.
• Technical know how of Linux/UNIX based platforms including shell variables, shell redirection, pipes, process control and file access rights.
• A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem solving skills.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• DTS
• SSIS 2008/2005
• SSRS 2008/2005
• SSAS 2008/2005
• T-SQL
• MS Visual Studio 2008/2005
• Erwin Data Modeler r7
• 4.2/4.1/4.0
• MS Access 2007/2003
• Index Tuning Wizard
• MS SQL Profiler
• Windows Server 2008/2003/2000
• Crystal Reports 11/10/9/8.5
• SharePoint 2007
• ASP .NET
• UNIX
• HTML
• XML
• JavaScript
• JSP
• Java
• Oracle 10g.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

MS SQL Developer/Data Warehouse Developer

Responsibilities:

• Interacting with the business analysts and the business users to determine where enhancements are needed, understanding the business requirements, and converting them into MS BI deliverables.
• Designing and maintaining SSIS packages that pull data from multiple data sources such as MRI, DST, Sales force, CFG and Informix into the databases. Monitoring and supporting these day to day processes.
• Using TSQL objects such as Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and Functions to design the logic for loading MRI data from source to the staging database, loading data into Sales force from the database using DBAmp (a third party tool for Sales force/SQL Server integration) and building ad hoc reports as per user’s requests.
• Using MS SQL Server Database Engine Index Tuning Wizard and SQL Profiler for performance monitoring and tuning. Improving performance of sluggish queries used by Reports by building indexes on the tables.
• Frequently using MS SQL Data Import/Export for a one time load of data from Sales force Excel/CSV files to the SQL Server tables.
• Designing a Job Metrics/Production Support report that lists the jobs that pull data from the various sources including the job names, the servers they run on, the load times and the type of data being pulled. Also, includes the number of records added, deleted, modified for each table.
• Monitoring the process that pulls data from MRI into Real Estate Data Warehouse. The data warehouse is loaded in an incremental fashion and stores history of the real estate data coming in.
• Maintaining the existing Real Estate Data Warehouse. As per requirements, adding new fields to the data warehouse by designing new or modifying existing SSIS packages which extract, transform and load data using various transformations, views, stored procedures and functions into the staging databases and data marts.
• Maintaining the existing cubes and creating new cubes with dimensions, measures and calculated members for slicing and dicing data from the Real Estate Data Warehouse. Using MDX expressions for the various calculated members, actions and KPIs.
• Creating various standard and ad hoc reports using MS Excel and Tableau 7.0/8.0 for the different departments such as Accounting, Property Management and ISRG (Investment Strategy and Research Group). Training the users in the design and use of the reports. Maintaining users and permissions on the tableau servers: UAT and PROD.
• Supporting existing development/analysis/testing/production platforms by troubleshooting development and production issues.
• Documentation of the nightly jobs that run on the different servers: DEV, UAT and PROD including the job names, the source system, which job runs on which server, the scheduled times, how they are triggered/dependency on other jobs, type of data being pulled, action to take if a step fails and the email notifications sent by each job.
• Documentation of data warehouse and the cubes including the ETL mappings between source, staging tables and data mart. Also, documenting the MDX queries, dimensions, measures and calculated members.
• After merger between Confidential, Inc. and Confidential, started work on the integration of data.

Tools: & Technologies: MS SQL Server 2008 R2, SSIS 2008 R2, SSAS 2008 R2, SSRS 2008 R2, T-SQL, SQL Server Management Studio, SQL Profiler, Erwin r7.2, Visual Studio 2005, DBAmp, Tableau 7.0/8.0, Windows 7.0.

Confidential, NY

Sr. MS SQL Developer

Responsibilities:

• Worked on Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
• Created and implemented physical databases from Logical Data Models.
• Involved in creating ER diagrams (Physical and Logical using Erwin) and mapping the data to the database objects.
• Involved in Data Modeling and Database Design of OLTP/OLAP and Dimensional Models.
• Constructed SQL Server database objects (DDL) and implementing queries (DML) that perform the business functions of the database models.
• Designed and developed Logical and Physical Database designs and Data modeling using the Erwin Data Modeler tool.
• Performed consistency checks using DBCC utilities to ensure the physical consistency of the database and objects.
• Used Index Tuning Wizard of the Database Engine and SQL Profiler for performance monitoring and tuning.
• Involved in T-SQL coding for Queries using Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and Functions.
• Used Visual Source Safe tool for Version Control.
• Tuning SQL query for better performance using SQL Profiler.
• Created SSIS packages to integrate and analyze data from multiple information sources such as CSV files, Excel, DB2, SQL 2000 and SQL 2005.
• Used the control flow components of SSIS such as For-Each Loop Container, Sequence Container, Script Task, Execute SQL Task, Send Mail Task, Execute Package Task, Variables and Expressions to achieve business needs.
• Performed multiple transformations such as Lookup, Derived Columns, Conditional Split, Aggregate, Pivot Transformation, Slowly Changing Dimension, Merge Join and Union All on the data.
• Used .NET in Script Task of SSIS to run SSIS packages with parameters being passed from .NET environment.
• Used T-SQL statements to filter data in the Staging database and to load data into the Enterprise Data Warehouse. Created Constraints and Triggers to ensure Data Consistency and Integrity.
• Created SQL Server Agent jobs to schedule SSIS packages using SQL Server Management Studio (SSMS).
• Used Package Configurations and Event Handlers in SSIS to make a package more portable and to handle errors in the packages.
• Developed yearly and quarterly reports using SSRS to record company expense.
• Created Stored Procedures to generate Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and Linked reports using SSRS.
• Responsible for Deployment of the reports using SSRS 2008.
• Used SQL profiler for performance tuning of SQL queries.
• Developed Custom Logging so that when a SSIS package extracted a row from DB2 to CDC DB or any insert, update or delete rows occurred in dimension tables or fact tables in the Data Warehouse, the user would come to know. Participated in weekly project meetings with the Project Manager to review the project and to ensure that the project meets the business and system requirements.

Tools: & Technologies: MS SQL Server 2008, SSIS 2008, SSRS 2008, T-SQL, Windows 2003 Server, SSMS, SQL Profiler, Erwin r7.2, Visual Studio 2005.

Confidential, NYC

MS SQL Developer/ETL Developer

Responsibilities:

• Modified existing SSIS packages. Added more alerts and audits in case of package failure.
• Created and deployed new SSIS packages to Extract, Transform and Load data using different transformations such as Aggregate, Conditional Split, Derived Columns, Pivot Transformation, Slowly Changing Dimension, Merge Join and UNION ALL.
• Worked with the Control Flow components of SSIS such as For-Each Loop Container, Sequence Container, Script Task, Execute SQL Task, Package Execution Task, FTP Task, Send Mail Task, Expressions and Variables to achieve business needs.
• Integrated and Analyzed data from multiple homogeneous and heterogeneous sources such as SQL 2008, SQL 2005, DB2, Excel, CSV and FTP Server.
• Defined the partition function and created schema for table partitioning.
• Designed, Developed and Deployed Tabular Reports, Matrix Reports, Drill-through Reports and Parameterized Reports using SSRS-2008.
• Used C# to invoke SSIS packages from .NET environment.
• Used SQL Profiler for Performance Tuning by tracing the slow running queries and the server activity in general.
• Created Documentation on Tables, Stored Procedures, Views and User Defined Functions.
• Implemented Constraints and Triggers for Data Consistency and to preserve Data Integrity.
• Scheduled and maintained packages on a daily, weekly and monthly basis using SQL Server Agent using SSMS.
• Created and modified various Stored Procedures and Functions.

Tools: & Technologies: MS SQL Server 2008, T-SQL, SSIS, SSRS, SQL Server Agent, MS SharePoint 2010, Visual Studio 2008, Windows 2008

Confidential, New York, NY

MS SQL Developer/ETL Developer

Responsibilities:

• Designed a Database and a Data Warehouse for the system using Star Schema.
• Maintained logical and physical data models required to migrate existing independent data marts into the EDW.
• Used Erwin r7 as the data modeling tool.
• Evaluated existing data models and physical databases for variances and discrepancies.
• Implemented SSIS package to perform ETL on data from OLTP systems such as Oracle, Flat Files, CSV, SQL 2005 and loading into the Staging Database using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Developed Stored Procedures and Triggers to handle complex business rules, data conversion, historical data, and audit analysis.
• Scheduled Stored Procedures and SSIS packages every mid-night and every week by creating SQL Server Agent jobs in SQL Server Management Studio (SSMS).
• Designed and Deployed Cubes in SSAS 2008 with around 45 dimensions, 25 measures and 20 calculated members. Created Fact and Dimension tables.
• Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Created Sub-reports, Drill-down reports, Matrix reports and Summary reports in SSRS 2008.
• Made use of Data Viewer in SSIS packages to check the data flow.
• Used Package Configurations and Event Handlers in SSIS to make a package more portable and to handle errors in the packages.
• Handled errors in Stored Procedures using @@error and with Try/catch.
• Worked with XML document structures and hierarchical data.
• Used SQL Profiler and Execution Plan for Performance Tuning.

Tools: & Technologies: MS SQL Server 2008, SSIS 2008, SSRS 2008, SSAS 2008, T-SQL, Erwin r7, SSMS

Confidential, Newark, NJ

MS SQL Server/Web Developer

Responsibilities:

• Interacted with medical professionals and gathered and documented the technical and business metadata.
• Involved in creating ER diagrams (Physical and Logical using Erwin) and mapping the data to the database objects.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created Backup and Restore operations for migrating database from one server to another.
• Created Database Triggers to implement business requirements.
• Transferred data from multiple OLTP systems like MS Access, CSV and Excel into SQL Server 2005 using SSIS packages.
• Involved in configuration of report server and report manager for scheduling reports.
• Granted permissions to different levels of users in SSRS 2005.
• Deployed and scheduled reports using SSRS 2005 to generate daily, weekly, monthly and quarterly reports including current status.
• Created a web-based application using Oracle 10g, JSP and Java to store and process data of stroke patients.
• The web application supported features for end users such as User Login and Registration, Adding and Deleting Users and Subjects from database, Generating Results of experiments conducted on Test Subjects and Automated Uploading of Multiple files using a single request at the end of each day.
• Participated in weekly project meetings with the Project Manager to review the project and to ensure that the project meets the business and system requirements.

Tools: & Technologies: MS SQL Server 2005, SSIS 2005, SSRS 2005, Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard, Erwin 4.0, Windows XP, MS Access, JSP, Java, Oracle 10g.

Confidential

MS SQL Server/Web Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development and user training.
• Participated in the installation of SQL Server. Installed SQL Server Enterprise Manager tools using SQL Server Setup Program.
• Transferred old data from various sources like Flat files, MS Access and Excel to SQL Server 2000 using DTS packages.
• Created Tables, Constraints, Views, Triggers, Indexes, Functions and Stored Procedures in T-SQL.
• Created Triggers to check the referential integrity and defined Stored Procedures for module integrity.
• Developed reports to generate daily, weekly, monthly, quarterly, yearly reports using Crystal Reports.
• Prepared test plans for assembly testing and system integration testing.
• Involved in Troubleshooting and Performance Tuning of the database and T-SQL queries.
• Developed a website and also a web page for a workshop conducted every year. Involved in creating the website from designing the theme to writing the source code using JavaScript, MySQL and PHP.
• The requirements for the workshop’s web page included supporting:
• User login and registration: Allowing new users participating in the workshop to register by creating a user name and password as per specifications. Each item should be stored in the MySQL table as a record/row.
• File upload: Enabling users to upload files which would be saved in the database.
• Automated email sending: On a successful registration, sending an email notification to the users confirming their registration and containing other details for the workshop.
• Chat forum: Implementing a simple chat system that would enable users to add, edit and delete messages.
• Form submission: Designing a simple form that would enable users to enter data into specified text boxes. The form also included Captcha code to prevent form spam.
• Participated in review meetings with the Project Manager and Project Investigator.
• Prepared Project Documentation.

Tools: & Technologies: MS SQL Server 2005, DTS, T-SQL, SQL Server Enterprise Manager 2005, Visual Basic, JavaScript, PHP, MySQL, Ubuntu/Linux.