SUMMARY

• Over 15 years of hands - on experience in Information Technology dat includes roles as a Developer, Team Lead and DBA.
• Experience in Architecture, Administration, System Analysis and Design, Development and Support of MS SQL Server and Oracle databases in Production, Test, Development and Cluster Server Environments.
• ExperitiseinDataModeling,DatabaseDesign,Programming,DevelopmentandImplementationofCIient-ServerApplications& DatabasesystemsusingSoftware Development Life Cycle (SDLC), documentation of software products wif Agile Scrum methodology and also experienced in working wif waterfall model.
• Extensiveworkknowledgeinhandlinghugedatabasesandworkedonperformancetuningandqueryoptimizations.
• Experience in Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of Bl application design anddevelopmentprincipals.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.

TECHNICAL SKILLS

• Oracle 9i/10g/11g/12c, SQL Server 2000/2008/2012/2016, DB2, Mongo DB, MySQL, Big Data, NoSQL, Hadoop, DW, ETL, MKS, CVS
• SSIS, SSRS, TSQL, PL/SQL, Informatica, Performance Tuning, Clustering, Replication, Windows, Linux
• Agile, Scrum, AHA, JIRA, Confluence, Invision, iOS, Android, React, Redux, Net, AWS, Azure, AI, API, Wireframes, mockups
• Data Integration, Data Governance, MDM, Data Quality, Reference data, Power BI, Draw.io, Balsamiq, Sketch
• Erwin, Visio, FTP, IIS, TCP/IP, VSS, Aldon, Magic/Remedy, Redgate, SQL Delta, BO, Crystal, Macola ERP, Spotlight. Lite-Speed
• Azure DW, Data Lake, HD Insight, Spark, Scala, C#, Java, Python, Git, Bitbucket

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Package.
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008/2012) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema, Snow-Flake
• Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboards.
• Wrote MDX Scripts to create datasets to for interactive drill down reports, report models and dashboard reports.
• Implemented data access security measures by identifying, analyzing and resolving security and system problems relating to data access security and applications.

Confidential

BI Lead

Responsibilities:

• Lead a team of developers, analysts and QA, both On-Site and offshore dedicated to enterprise BI and data warehousing programs wifin teh Risk Management division of Jefferies.
• Established cross-functional relationships and directed all requirements gathering, data analysis and documentation for enterprise projects to centralize risk data into a single multi-terabyte data warehouse wif advanced reporting.
• DesignedSSISPackages,and/orenhancedtheexistingSSISpackagesusingPivotTransformation,FuzzyLookup,DerivedColumns, ConditionalSplit,Aggregate,ExecuteSQLTask,andDataFlowTasketc.toextractdatafromdisparatesources(SQLServer,Oracle, andExcel)to generateunderlyingdatafortheirports.
• Validatedthedaily,weekly,monthlygraintransformeddatabycomparingitwifthesourcesystem.
• Workedwifinternalcustomerstogatherandanalyzebusinessrequirementsinordertoidentifyandsolveproblems.
• Responsibleforbuildingtheirportsolutionlikedrilldown,drillthrough,andlinkedreportsusingSSRS,testingforqualityandfinallyreviewwifthe customertoensurethesolutionmeetsrequirements.
• Supportedtheefficientdeliveryofstandardandad-hocreportswiTEMPthanemphasisonautomatingwherepossible.
• Generatedweekly,monthlyandquarterlyreportsforthemanagementusingdifferenttechniqueslikedatafiltering,addinginteractivity,deployingreportstoreportserverinSSRS.WorkedwifColumnstoreindexes,tablepartitioninginSQLServer2012.

Confidential, Washington. D.C

Responsibilities:

• Currency Trading application (GlobalPay), DB Migration. Launched development of various IT teams and implemented a comprehensive enterprise-wide technological strategy to support teh business plan.
• Oversaw development, improvement, and management of GlobalPay platform, business intelligence reporting services and data warehouse for WUBS B2B payment application. Developed IT governance framework including policies and procedures.
• Supervised multi-departmental task force including DBA’s and Developers, Code reviews, change management, including 11 direct reports, resolve issues wif data management infrastructure, formulation of corporate metrics, and reporting.
• Understand current/changing business processes, participated in defining application and platform functionality.
• Responsible for all phases of teh SDLC including gathering requirements, data/system analysis, data modeling, ETL development, database development, testing, deployment, UAT etc. Managed global relationships wif vendors and consultants.
• DevelopedSSISpackagesusingFuzzyLookUpandFuzzyGroupingfordatacleansingpurpose.
• UsedSSISVariablesforstoringthevalues,whichareusedinvariouscomponentsofDataFlowTask.
• ModifedtheexistingSSISpackagestomeetthechangesspecifiedbytheusers, UnitTestPlansforSSISpackages.
• ExtensivelyusedSSIStransformationssuchasLookup,Derivedcolumn,Dataconversion,Aggregate,Conditionalsplit,SQLtask,Scripttaskand SendMailtasketc.
• DevelopedAggregations,PartitionsandCalculatedMembersforcubeasperbusinessrequirements.
• Designed,DevelopedandDeployedParameterizedreports,DrilldownandDrillthroughinMSSQLServer usingSSRS2008.
• Scheduledthemonthly/weekly/dailyreportstorunautomaticallyontotheDashboard.

Confidential, Maryland

Database Architect

Responsibilities:

• Provided project management services/expertise to business applications group responsible for enterprise systems.
• InteractingwifBusinessusers,gatheringandanalyzingrequirements. Workedintest-basedDevelopmentprocess.
• WorkedoncreatingAnalysisandmappingdocuments. CreatedSSISDataMigrationTemplateusingSQLServer2008.
• InvolvedindevelopingPackagesforimplementingbusinesslogicthroughStoredProceduresandFunctions.
• Migrateddatafromlegacysystem(text-basedfiles,Excelspreadsheets)toSQLServerdatabasesusingSQLServer
• Createddatabasesandschemaobjectsincludingtables,indexesandappliedconstraints,connectedvariousapplicationstothe databaseandwritten functions,storedproceduresandtriggers.
• AnalyzelargedatasetsandpatternsusingTSQL,PowerBI,advancedExcelmodelslikePowerPivotandPowerQuerytoidentify opportunitiesand risksincurrentoperationsanddefinesolutionsindailybusinessoperations.
• ExperienceinbuildingSSISpackages(.dtsx)involvingETLprocess,extractingdatafromvariousflatfiles,Excelfiles,legacy systemsandloadinginto SQLserver. CreateCalculatememberinMOLAPcubeusingMDXinSSAS2008.
• HandsonexperienceworkingwifSSIS,forETLprocessensuringproperimplementationofEventHandlers,Leggings, Checkpoints,Transactionsandpackageconfigurations.InvolvedinimplementingKPIObjectsinSSAS2008.

Confidential

Product Manager / Technical Lead

Responsibilities:

• ERP Implementation, Order Management System, EDI Application. Transportation Management & Reporting System.
• Increased productivity and systems availability wif new operational processes and standards.
• Authored project proposals, defined scope of work, cost estimates, schedules, budgets, and resource requirements.