SUMMARY

• Over 5+ years of extensive experience in database development and IT Solutions dat include experience in design, development and implementation of complex data delivery systems using MS SQL Server and various data visualization tools.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML), which includes Use Cases, Sequence, State and Activity diagrams, Data mapping, participated in architectural design and class design.
• Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Snowflake, Normalized and De - Normalized Schemas with respect to query and analysis requirements.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Strong experience in creating variety of business reports using SQL SSRS based on Relational and OLAP
• Experienced in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Teradata, Sybase, Excel and MS Access CSV, flat file.
• Experience in implementing incremental data Loads and slowly changing dimensions (SCD) using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS Packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Experience in implementing Transactions and using configurations to deploy SSIS Packages into different environments.
• Experience in developing dashboards, Scorecards, KPI's, Indicators, Analytic Charts, Strategy Maps and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SSRS and Report Builder.
• Experience in the integration of SSRS Reports using various web parts into Dashboards and SharePoint
• Experience in using custom code (vb.net), variables, expressions, and functions for the reports and in handling Parameterized reports, in writing sub reports and parameterized Queries for generating reports in SSRS 2008.
• Developed Dashboard Reports using Performance Point Server on SharePoint, SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Experience in creating Multidimensional cubes using SSAS, Multi-Dimensional Expressions (MDX) queries and Data Mining Extensions (DMX) queries for Analysis Services & Reporting Services. Implemented cell level security in cubes.
• Experience in Querying a Tabular Model in Excel, Power View and used various DAX Functions. Loading Data inside Tabular, Monitoring Security, Automating Deployment to Production Server.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server 2016,2014,2012,2008R2,2008,2005,2000, Oracle 9i/10g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot. Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Business Intelligence (ETL, SSIS, SSRS)/SQL Server Developer

Responsibilities:

• DesignedSSISpackages to load data from different sources Text files, Excel to staging and staging to Data warehouse.
• Applied different transformations,Control,Lookups,SCD,and DerivedColumnto easily migrate SSIS package from one server to another.
• Implemented the concepts ofIncrementalDataLoad, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Scheduled theETLProcess using Jobs. Created Alerts for successful and unsuccessful completion of scheduled jobs in SQL Server Agent.
• Reduced the overall ETL Time by SQLQueryPerformanceTuning, Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Scheduled batch scripts inSQLAgentwith various steps to run the SSIS packages.
• Designed and implemented various Parameterized and cascading parameterized reports.
• Created and integratedUserDefinedFunctionsand Stored Procedures for reporting purposes.
• CreatedCharts,TabularandMatrixreports using SSRS andCrystalReportswith/withoutDrilldown.
• Created Crystal Reports and hosted them in the web for the users.
• Generating reports dat ca handle DynamicGroupingand DynamicSorting.
• CreatedAd-HocReports, Summary Reports,SubReportsand Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS).
• Creation ofClusteredandNon-ClusteredIndexes for query performance and generated various reports using complex stored procedures.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages and PDA as well as window messengers.
• Participated in requirement gathering,Cubedesign, Application design,SSASDevelopment.
• Data Definition and Data Manipulation Languages (DDL,DML) implementing constraints and triggers for data integrity in development database for warehouse system.
• PerformanceTuningof Queries and Stored Procedures.
• Worked extensively in writing and debugging complex Stored Procedures, Triggers, Inner Joins, Outer Joins, Views and User Defined Functions.

Environment: SQL Server 2016/ 2014/2012/2008 R2, Crystal Reports XI/10, SSIS, SSRS, SSAS, T-SQL, Windows Server 2008/2008 R2 Visual Studio 2008

Confidential, Philadelphia, PA

SQL/BI Developer

Responsibilities:

• Worked closely with data architects and provided valuable inputs on building a new database design.
• Identified the list of SQL objects which needs to be worked on by the requirements given by business.
• Red gate’s SQL search tool TEMPhas been used to identify the list of SQL objects using the requirements given.
• Analyzed all SQL objects and documented code rationalization.
• AnalyzedReferential Integrityof the database and documented and replicated the same to another database with better changes wherever needed.
• Created tables withprimaryandforeignkeys to satisfy the database design.
• CreatedSynonymsto give an alias to an already existing or potential new object.
• CreatedSchemasto simplify administration of security, backup and restore.
• ImplementedPerformance Tuningstrategies to make the application run faster.
• Created complex stored procedures to load the data from one database to another on a daily bases, by implementingrestart ability,traceability,change data capture(CDC) andcode rationalization.
• Scheduled jobs to executeStored Procedureswhich were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Extracted data from internal data warehouse system to SSRS
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization
• Analyzeddata models,data relationships, and dependencies for greatest optimization
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• DesignedER diagramsand mapped the data into database objects and involved in normalization of the database in OLTP.

Environment: SQL Server 2014/2012/2008 R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007, C#.

Confidential, Richmond, VA

MS SQL Server - SSRS /SSIS/SSAS Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Worked in the Agile methodology using Scrum which TEMPhas its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Implemented slowly changing Dimensions using slowly changing dimension Transformation for SCD Type 2. Used Combination of Derived column and look up transformation to implement SCD type 2 for high volume of data.
• Implemented incremental load and SCD type 1 using Look-up Transformation. Also performed data cleansing using Look up and Fuzzy Look up and Fuzzy Grouping Transformations.
• Created C# Scripts for Control Flow and Check File existence using Script task in SSIS and land file securely on Application Server and then copied those files to FTP and Mainframe Servers.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.
• Deployed SSRS Reports in SharePoint for web based access for multiple end users
• Created ad-hoc reports for business users using Report Designer and Report Builder.
• Created data driven subscriptions to send the reports in desired format and report snapshots.
• Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, measures, generating KPI.
• Created Views and stored procedures to reduce database complexities for the end users and to load data in to different tables.
• Performed Query optimization &Performance Tuning using SQL Profiler and Database engine tuning advisor.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS 2005, SSRS 2005, .NET Framework, ASP.NET, Erwin, T-SQL, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, XML, MS Excel, MS Access, Visual Studio 2005.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.